CREATE TABLE IF NOT EXISTS `characters` (
  `ID` int(32) NOT NULL auto_increment,
  `Username` varchar(32) NOT NULL,
  `Name` varchar(32) NOT NULL,
  `FirstName` varchar(32) NOT NULL,
  `LastName` varchar(32) NOT NULL,
  `Textures0` int(32) NOT NULL default '0',
  `Textures1` int(32) NOT NULL default '0',
  `Textures2` int(32) NOT NULL default '0',
  `Textures3` int(32) NOT NULL default '0',
  `Textures4` int(32) NOT NULL default '0',
  `ZoneID` int(32) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `H1` float NOT NULL,
  `H2` float NOT NULL,
  `H3` float NOT NULL,
  `H4` float NOT NULL,
  `Online` smallint(6) default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
